Film_Locations_in_San_Francisco

Data source: data.sfgov.org

15 rows where Release Year = 65

View and edit SQL

Suggested facets: Title, Fun Facts, Production Company, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1244 Sudden Impact 231 1983 65 Near Point Lobos, El Camino Del Mar   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176  
1245 Sudden Impact 231 1983 65 Mt. Davidson Mt. Davidson is highest point in San Francisco (938 feet). Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1246 Sudden Impact 231 1983 65 McDonald's Restaurant (701 3rd Street, SOMA)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1247 Sudden Impact 231 1983 65 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1248 Sudden Impact 231 1983 65 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1249 Sudden Impact 231 1983 65 Ferry Plaza Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1250 Sudden Impact 231 1983 65 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1251 Sudden Impact 231 1983 65 Civic Center Plaza   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1252 Sudden Impact 231 1983 65 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1253 Sudden Impact 231 1983 65 Bowles Franklin Galleries (765 Beach Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1254 Sudden Impact 231 1983 65 Pier 38-40, The Embarcadero   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Clint Eastwood 113 Harry Julian Fink 71 Clint Eastwood 295 Sondra Locke 176 Pat Hingle 522
1483 The Right Stuff 279 1983 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1484 The Right Stuff 279 1983 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1485 The Right Stuff 279 1983 65 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1486 The Right Stuff 279 1983 65 Financial District   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 39.342ms · Data source: data.sfgov.org